[dbo].[BAEOrderAttributeValuesForSuperProduct]
create procedure [dbo].[BAEOrderAttributeValuesForSuperProduct] @OrderProductID as
int,
@OrderSuperProductAttributeID AS int
AS
SELECT DISTINCT av.* FROM OrderSuperProductAttributeValue AS av
JOIN OrderSuperProductChildProductAttribute pa ON
pa.OrderSuperProductAttributeValueID = av.OrderSuperProductAttributeValueID
JOIN OrderSuperProductChildProduct cp ON
cp.OrderSuperProductChildProductID = pa.OrderSuperProductChildProductID
WHERE cp.OrderProductID = @OrderProductID AND av.OrderSuperProductAttributeID = @OrderSuperProductAttributeID
GO
